package com.yngrp.entity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;

import org.jeecgframework.core.common.entity.IdEntity;
import org.jeecgframework.poi.excel.annotation.Excel;

/**
 *  @Description: 集团户号
 *  @author  SLH
 *  @date  20160811
 */

@Entity
@Table(name = "yl_group_customerno")
public class Group2CustomerNo extends IdEntity implements java.io.Serializable{
	private static final long serialVersionUID = 1L;
	
	/**关联集团实体**/
	private GroupInfo groupInfo;
	
	/**排序号**/
	@Excel(name = "排序号",width = 15)
	private String sno;
	
	/**集团户号**/
	@Excel(name = "户号",width = 25)
	private String customerNo;
	
	/**电费查询方式编码**/
	private String queryMode;
	
	/**电费查询方式描述**/
	@Excel(name = "查询方式",width = 15)
	private String queryModeDesc;
	
	/**户名**/
	@Excel(name = "户名",width = 30)
	private String customerName;
	
	/**地址**/
	@Excel(name = "地址",width = 40)
	private String customerAddress;
	
	@ManyToOne(fetch = FetchType.EAGER)
	@JoinColumn(name = "group_id")
	public GroupInfo getGroupInfo() {
		return groupInfo;
	}

	public void setGroupInfo(GroupInfo groupInfo) {
		this.groupInfo = groupInfo;
	}

	@Column(name ="customer_no")
	public String getCustomerNo() {
		return customerNo;
	}

	public void setCustomerNo(String customerNo) {
		this.customerNo = customerNo;
	}

	@Column(name ="customer_name")
	public String getCustomerName() {
		return customerName;
	}

	public void setCustomerName(String customerName) {
		this.customerName = customerName;
	}

	@Column(name ="customer_address")
	public String getCustomerAddress() {
		return customerAddress;
	}

	public void setCustomerAddress(String customerAddress) {
		this.customerAddress = customerAddress;
	}

	@Column(name ="sno")
	public String getSno() {
		return sno;
	}

	public void setSno(String sno) {
		this.sno = sno;
	}

	@Column(name ="querymode")
	public String getQueryMode() {
		return queryMode;
	}

	public void setQueryMode(String queryMode) {
		this.queryMode = queryMode;
	}

	@Column(name ="querymode_desc")
	public String getQueryModeDesc() {
		return queryModeDesc;
	}

	public void setQueryModeDesc(String queryModeDesc) {
		this.queryModeDesc = queryModeDesc;
	}

}
